﻿using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace StatsData.Data.Migrations
{
    public partial class add_th_label : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_WORK",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_SHIPMENT_EXAMINE",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_SHIPMENT",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_QC_EXCEPTION",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_QC",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_PRODUCE_STATIS",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_OWE",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_OTD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "NAME_TH",
                table: "T_ORGANIZATION",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "NAME_TH",
                table: "T_MOTION",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_MANUFACTURING_RATE",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_LINE_MOTION",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_LINE_FPY_BASE",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_LINE_FPY",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "PROCEDURE_TOP_BAD_TH",
                table: "T_LINE_FPY",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_LINE",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "DATE_TYPE_TH",
                table: "T_KPI_STATIS",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_KPI_STATIS",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "PROCEDURE_NAME_TH",
                table: "T_KPI_STATIS",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "TITLE_TH",
                table: "T_KPI_STATIS",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_IN_PROCESS_WORK",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_FPY",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "DEPT_NAME_TH",
                table: "T_EXCEED",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "NAME_TH",
                table: "T_DEPARTMENT",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "DESCRIPTION_TH",
                table: "T_BI_WIP_ISSUE_RECORD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_BI_WIP_ISSUE_RECORD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "SHOP_DEPART_NAME_TH",
                table: "T_BI_WIP_ISSUE_RECORD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "SOLUTION_TH",
                table: "T_BI_WIP_ISSUE_RECORD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_BI_LINE_SAFETY",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "DEPARTMENT_NAME_EN",
                table: "T_BI_DEPART_ATTENDANCE",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "DEPARTMENT_NAME_TH",
                table: "T_BI_DEPART_ATTENDANCE",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_BI_CROSS_SEND_REPAIR_DETAIL",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "BAD_NAME_TH",
                table: "T_BAD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_BAD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "PRODURE_NAME_TH",
                table: "T_BAD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "TYPE_TH",
                table: "T_BAD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "IP_TYPE_TH",
                table: "T_ANDON_DATA",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "I_REMARK_TH",
                table: "T_ANDON_DATA",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "I_TYPE_TH",
                table: "T_ANDON_DATA",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_TH",
                table: "T_ANDON_DATA",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_WORK");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_SHIPMENT_EXAMINE");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_SHIPMENT");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_QC_EXCEPTION");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_QC");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_PRODUCE_STATIS");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_OWE");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_OTD");

            migrationBuilder.DropColumn(
                name: "NAME_TH",
                table: "T_ORGANIZATION");

            migrationBuilder.DropColumn(
                name: "NAME_TH",
                table: "T_MOTION");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_MANUFACTURING_RATE");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_LINE_MOTION");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_LINE_FPY_BASE");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_LINE_FPY");

            migrationBuilder.DropColumn(
                name: "PROCEDURE_TOP_BAD_TH",
                table: "T_LINE_FPY");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_LINE");

            migrationBuilder.DropColumn(
                name: "DATE_TYPE_TH",
                table: "T_KPI_STATIS");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_KPI_STATIS");

            migrationBuilder.DropColumn(
                name: "PROCEDURE_NAME_TH",
                table: "T_KPI_STATIS");

            migrationBuilder.DropColumn(
                name: "TITLE_TH",
                table: "T_KPI_STATIS");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_IN_PROCESS_WORK");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_FPY");

            migrationBuilder.DropColumn(
                name: "DEPT_NAME_TH",
                table: "T_EXCEED");

            migrationBuilder.DropColumn(
                name: "NAME_TH",
                table: "T_DEPARTMENT");

            migrationBuilder.DropColumn(
                name: "DESCRIPTION_TH",
                table: "T_BI_WIP_ISSUE_RECORD");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_BI_WIP_ISSUE_RECORD");

            migrationBuilder.DropColumn(
                name: "SHOP_DEPART_NAME_TH",
                table: "T_BI_WIP_ISSUE_RECORD");

            migrationBuilder.DropColumn(
                name: "SOLUTION_TH",
                table: "T_BI_WIP_ISSUE_RECORD");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_BI_LINE_SAFETY");

            migrationBuilder.DropColumn(
                name: "DEPARTMENT_NAME_EN",
                table: "T_BI_DEPART_ATTENDANCE");

            migrationBuilder.DropColumn(
                name: "DEPARTMENT_NAME_TH",
                table: "T_BI_DEPART_ATTENDANCE");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_BI_CROSS_SEND_REPAIR_DETAIL");

            migrationBuilder.DropColumn(
                name: "BAD_NAME_TH",
                table: "T_BAD");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_BAD");

            migrationBuilder.DropColumn(
                name: "PRODURE_NAME_TH",
                table: "T_BAD");

            migrationBuilder.DropColumn(
                name: "TYPE_TH",
                table: "T_BAD");

            migrationBuilder.DropColumn(
                name: "IP_TYPE_TH",
                table: "T_ANDON_DATA");

            migrationBuilder.DropColumn(
                name: "I_REMARK_TH",
                table: "T_ANDON_DATA");

            migrationBuilder.DropColumn(
                name: "I_TYPE_TH",
                table: "T_ANDON_DATA");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_TH",
                table: "T_ANDON_DATA");
        }
    }
}
